NozzleFuelingTransactionHistory

Entity Definition

Logical Name : NozzleFuelingTransactionHistory
Physical Name : LE_HST_NZL_TRN

The total number, volume and monetary value of all FuelingTransactions performed on a particular LogicalNozzle during a particular ReportingPeriod. Totals are separated by Prepay and Postpay FuelingTransactions

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_BSN_UN Identity integer Nozzle(AS_NZL)
FuelingPointID (FK)(PK) A unique identifier for the FuelingPoint at a particular retail store ID_PNT_FUEL Identity integer Nozzle(AS_NZL)
NozzleID (FK)(PK) A unique identifier for the Nozzle ID_NZL Identity integer Nozzle(AS_NZL)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
ServiceLevelID (FK)(PK) A unique identifier for the service level ID_LV_SV Identity integer FuelServiceLevel(CO_LV_SV)
PriceLevelID (FK)(PK) A unique identifier for the price level ID_LV_PRC Identity integer FuelPriceLevel(CO_LV_PRC)
TimeGroupID (FK)(PK) A unique identifier for a set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. ID_GP_TM Identity integer TimeGroup(CO_GP_TM)
OperatorID (FK)(PK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
PostpayFuelingTransactionCount The number of FuellingTransactions performed at the LogicalNozzle during the ReportingPeriod QU_TRN_FUEL_PSPY QuantityTransactionCount decimal(7,0)
PostpayFuelingTransactionVolume The total volume of FuellingTransactions performed at the LogicalNozzle during the ReportingPeriod QV_TRN_FUEL_PSPY Quantity decimal(9,2)
PostPayFuelingTransactionAmount The total monetary amount of FuellingTransactions performed at the LogicalNozzle during the ReportingPeriod MO_TRN_FUEL_PSPY Money decimal(16,5)
PrepayFuelingTransactionCount The count of fueling transactions prepaid at the logical nozzle during the reporting period. QU_TRN_FUEL_PRPY QuantityTransactionCount decimal(7,0)
PrepayFuelingTransactionVolume The total volume of fueling transactions prepaid at the logical nozzle during the reporting period. QV_TRN_FUEL_PRPY Quantity decimal(9,2)
PrepayFuelingTransactionAmount The total monetary amount of FuellingTransactions prepaid at the LogicalNozzle during the ReportingPeriod MO_TRN_FUEL_PRPY Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
FuelServiceLevel is summarized to NozzleFuelingTransactionHistory
Nozzle is summarized to NozzleFuelingTransactionHistory
ReportingPeriod delineates NozzleFuelingTransactionHistory
TimeGroup is summarized to NozzleFuelingTransactionHistory
FuelPriceLevel is summarized to NozzleFuelingTransactionHistory
Operator is summarized to NozzleFuelingTransactionHistory

Logical Views containing NozzleFuelingTransactionHistory

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 06500 - Time Groups View
Logical 20040 - Forecourt History View